Not operator

Basic and Crystal syntax.

Usage

not (x)

Reverses the True or False value of x.

Value of x Not x

True

False

False

True

Examples

The following examples are applicable to both Basic and Crystal syntax:

not (A>B and B>C)

If A=5, B = 4, C = 3, the expression (A>B and B>C) is TRUE. Both conditions tied together by the Boolean operator And are TRUE; thus, the entire statement has a value of TRUE. The Not operator changes the value of the expression to FALSE.

not (A>B and B>C)

If A=3, B = 4, C = 3, the expression (A>B and B>C) is FALSE. One of the two conditions tied together by the Boolean operator And is FALSE; thus, the entire statement has a value of FALSE. The Not operator changes the value of the expression to TRUE.

not ({file.ONHAND} - {file.ORDER} > 0)

Returns TRUE if {file.ONHAND} = 10 and {file.ORDER} = 11.

not ({file.ONHAND} - {file.ORDER} > 0)

Returns FALSE if {file.ONHAND} = 10 and {file.ORDER} = 9.

Related topics

Formula 10



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com